﻿CREATE VIEW `wordpress`.`posts` AS
SELECT wp_posts.*, wp_users.display_name AS author FROM wp_posts INNER JOIN wp_users ON wp_posts.post_author = wp_users.ID WHERE wp_posts.post_type = 'post' AND wp_posts.post_status = 'publish'